Agile Data Warehouse Design: Collaborative Dimensional Modeling, from Whiteboard to Star Schema

Agile Data Warehouse Design: Collaborative Dimensional Modeling, from Whiteboard to Star Schema

  • Downloads:9871
  • Type:Epub+TxT+PDF+Mobi
  • Create Date:2021-03-06 03:16:52
  • Update Date:2025-09-06
  • Status:finish
  • Author:Lawrence Corr
  • ISBN:0956817203
  • Environment:PC/Android/iPhone/iPad/Kindle

Summary

Agile Data Warehouse Design is a step-by-step guide for capturing data warehousing/business intelligence (DW/BI) requirements and turning them into high performance dimensional models in the most direct way: by modelstorming (data modeling + brainstorming) with BI stakeholders。 This book describes BEAM✲, an agile approach to dimensional modeling, for improving communication between data warehouse designers, BI stakeholders and the whole DW/BI development team。 BEAM✲ provides tools and techniques that will encourage DW/BI designers and developers to move away from their keyboards and entity relationship based tools and model interactively with their colleagues。 The result is everyone thinks dimensionally from the outset! Developers understand how to efficiently implement dimensional modeling solutions。 Business stakeholders feel ownership of the data warehouse they have created, and can already imagine how they will use it to answer their business questions。 Within this book, you will learn: ✲ Agile dimensional modeling using Business Event Analysis & Modeling (BEAM✲) ✲ Modelstorming: data modeling that is quicker, more inclusive, more productive, and frankly more fun! ✲ Telling dimensional data stories using the 7Ws (who, what, when, where, how many, why and how) ✲ Modeling by example not abstraction; using data story themes, not crow's feet, to describe detail ✲ Storyboarding the data warehouse to discover conformed dimensions and plan iterative development ✲ Visual modeling: sketching timelines, charts and grids to model complex process measurement - simply ✲ Agile design documentation: enhancing star schemas with BEAM✲ dimensional shorthand notation ✲ Solving difficult DW/BI performance and usability problems with proven dimensional design patterns Lawrence Corr is a data warehouse designer and educator。 As Principal of DecisionOne Consulting, he helps clients to review and simplify their data warehouse designs, and advises vendors on visual data modeling techniques。 He regularly teaches agile dimensional modeling courses worldwide and has taught dimensional DW/BI skills to thousands of students。 Jim Stagnitto is a data warehouse and master data management architect specializing in the healthcare, financial services, and information service industries。 He is the founder of the data warehousing and data mining consulting firm Llumino。

Download

Reviews

Yasmine Dumouchel

Very well written and actionable。 Presents a pragmatic and structured methodology to gathering requirements in DW/BI context at the same time as using dimensional modelling。 It is a more practical version of Kimball's book。 Very well written and actionable。 Presents a pragmatic and structured methodology to gathering requirements in DW/BI context at the same time as using dimensional modelling。 It is a more practical version of Kimball's book。 。。。more

John Brian Anderson

Very good system。 If you have the discipline to follow this you can create a functional data warehouse。 More geared for a consultant though, hard to see how you would go through this for only one company。

Hunter Johnson

Excellent overview, and supported by a worthwhile website with downloads。 A few items were presented as things to do without enough reason why。 But I took several good ideas from it to implement immediately。

Hillary

Very well written, easy to read style, excellent real world examples。 The main thing was not just what to do, but why。 I learn best when I truly understand and this book gave me what I was looking for。

Daniel Galassi

I think the authors put together two important aspects of BI solution design, a design methodology and a good introduction to dimensional modelling。 I found the methodology easy to follow and formulated in a way that can be used with business users。The methodology is probably easier to implement in greenfield implementations, since "reverse engineering" a mid-sized data warehouse and generate the necessary supporting elements may be a time consuming activity。 That said, the methodological approa I think the authors put together two important aspects of BI solution design, a design methodology and a good introduction to dimensional modelling。 I found the methodology easy to follow and formulated in a way that can be used with business users。The methodology is probably easier to implement in greenfield implementations, since "reverse engineering" a mid-sized data warehouse and generate the necessary supporting elements may be a time consuming activity。 That said, the methodological approach of BEAM* would help consulting teams tremendously。Big thumbs up! 。。。more